CheckTenderLineItem

Entity Definition

Logical Name : CheckTenderLineItem
Physical Name : TR_LTM_CHK_TND

A sub-type of TenderLineItem that records the specifics about a check received from a customer in settling a transaction.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
TransactionID (FK)(PK) A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. ID_TRN IdentityUUID char(32)
RetailTransactionLineItemSequenceNumber (FK)(PK) The sequence number of line item within the context of this RetailTransaction. IC_LN_ITM LineNumber smallint
FullMICR The complete string of characters read from the MICR (Magnetic Ink Character Recognition) strip. Content varies by Country and/or Financial Institution but it usually contains BankID, CheckAccountNumber and CheckSequenceNumber - but there may be more data encoded in the MICR. ED_FLL_MICR IdentityAlphaNumeric varchar(20)
BankID The unique identifier of the bank or third party authorization center. ID_BK_CHK Identity integer
CheckAccountNumber The check account number of CUSTOMERs whose checks have been previously honored or rejected. Retaining a check history by CUSTOMER provides the RETAIL STORE with a means of tender authorization. ID_ACNT_CHK Identity integer
CheckAccountNumberEntryMethodCode A code denoting how the CheckAccountNumber was entered into the system. LU_MTH_ACNT_ENR Code varchar(20)
CheckSequenceNumber A unique sequence number relating to a particular check authorization. AI_CHK LineNumber smallint
CheckSequenceNumberEntryMethodCode A code denoting how the CheckSequenceNumber was entered into the system. LU_MTH_SQN_ENR Code varchar(20)
PersonalIDRequiredTypeCode Identifies the type of personal identification required to authorize tender. Examples include driver's license, a second credit card, social security card, etc. TY_ID_PRSL_RQ Code2 char(2)
PersonalIDNumber The personal identification number that must be keyed by an individual at the point of sale when paying by personal check. ID_PRSL_AZN Identity integer
AdjudicationCode A code to denote that approval has been received from the authorization center. ID_ADJN_CHK Code4 char(4)
CustomerBirthDate The customer's date of birth captured as part of the personal data required to verify their identity and authorize their use of a check to pay for a purchase. DC_BRT_CHK DateCalendarDay char(2)
CheckCardNumber The number from a bank issued card guaranteeing checks up to a certain value. ID_CRD_CHK Name varchar(40)
CheckTypeCode A code the designates whether the check is a PERSONAL or BUSINESS check. CD_CK_TYP Code varchar(20)

Relationships

Parent Entity Verb Phrase Child Entity
TenderLineItem can be a CheckTenderLineItem

Logical Views containing CheckTenderLineItem

Logical View
Logical 02300 - Retail Transaction - Macro View
Logical 02330 - Retail Transaction - Tender - Macro View
Logical 07040 - Customer Segment Dependent Behavior